[dbo].[BAECartEventFunctionUpdate]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAECartEventFunctionUpdate
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@CartEventFunctionID
int
4
@CartEventID
int
4
@FunctionCode
varchar(32)
32
@Quantity
int
4
@Title
varchar(128)
128
@Price
money
8
SQL Script
create
procedure
[dbo]
.
[BAECartEventFunctionUpdate]
@CartEventFunctionID
as
int
,
@CartEventID
AS
int
,
@FunctionCode
AS
varchar
(
32
),
@Quantity
AS
int
,
@Title
AS
varchar
(
128
),
@Price
AS
money
AS
UPDATE
CartEventFunction
SET
CartEventID
=
@CartEventID
,
FunctionCode
=
@FunctionCode
,
Quantity
=
@Quantity
,
Title
=
@Title
,
Price
=
@Price
WHERE
CartEventFunctionID
=
@CartEventFunctionID
;
GO
Uses
[dbo].[CartEventFunction]
dbo